package com.emex.app.shared.data;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class JuridicalPersonExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public JuridicalPersonExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andReductNameIsNull() {
            addCriterion("reduct_name is null");
            return (Criteria) this;
        }

        public Criteria andReductNameIsNotNull() {
            addCriterion("reduct_name is not null");
            return (Criteria) this;
        }

        public Criteria andReductNameEqualTo(String value) {
            addCriterion("reduct_name =", value, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameNotEqualTo(String value) {
            addCriterion("reduct_name <>", value, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameGreaterThan(String value) {
            addCriterion("reduct_name >", value, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameGreaterThanOrEqualTo(String value) {
            addCriterion("reduct_name >=", value, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameLessThan(String value) {
            addCriterion("reduct_name <", value, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameLessThanOrEqualTo(String value) {
            addCriterion("reduct_name <=", value, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameLike(String value) {
            addCriterion("reduct_name like", value, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameNotLike(String value) {
            addCriterion("reduct_name not like", value, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameIn(List<String> values) {
            addCriterion("reduct_name in", values, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameNotIn(List<String> values) {
            addCriterion("reduct_name not in", values, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameBetween(String value1, String value2) {
            addCriterion("reduct_name between", value1, value2, "reductName");
            return (Criteria) this;
        }

        public Criteria andReductNameNotBetween(String value1, String value2) {
            addCriterion("reduct_name not between", value1, value2, "reductName");
            return (Criteria) this;
        }

        public Criteria andInnIsNull() {
            addCriterion("inn is null");
            return (Criteria) this;
        }

        public Criteria andInnIsNotNull() {
            addCriterion("inn is not null");
            return (Criteria) this;
        }

        public Criteria andInnEqualTo(String value) {
            addCriterion("inn =", value, "inn");
            return (Criteria) this;
        }

        public Criteria andInnNotEqualTo(String value) {
            addCriterion("inn <>", value, "inn");
            return (Criteria) this;
        }

        public Criteria andInnGreaterThan(String value) {
            addCriterion("inn >", value, "inn");
            return (Criteria) this;
        }

        public Criteria andInnGreaterThanOrEqualTo(String value) {
            addCriterion("inn >=", value, "inn");
            return (Criteria) this;
        }

        public Criteria andInnLessThan(String value) {
            addCriterion("inn <", value, "inn");
            return (Criteria) this;
        }

        public Criteria andInnLessThanOrEqualTo(String value) {
            addCriterion("inn <=", value, "inn");
            return (Criteria) this;
        }

        public Criteria andInnLike(String value) {
            addCriterion("inn like", value, "inn");
            return (Criteria) this;
        }

        public Criteria andInnNotLike(String value) {
            addCriterion("inn not like", value, "inn");
            return (Criteria) this;
        }

        public Criteria andInnIn(List<String> values) {
            addCriterion("inn in", values, "inn");
            return (Criteria) this;
        }

        public Criteria andInnNotIn(List<String> values) {
            addCriterion("inn not in", values, "inn");
            return (Criteria) this;
        }

        public Criteria andInnBetween(String value1, String value2) {
            addCriterion("inn between", value1, value2, "inn");
            return (Criteria) this;
        }

        public Criteria andInnNotBetween(String value1, String value2) {
            addCriterion("inn not between", value1, value2, "inn");
            return (Criteria) this;
        }

        public Criteria andKppIsNull() {
            addCriterion("kpp is null");
            return (Criteria) this;
        }

        public Criteria andKppIsNotNull() {
            addCriterion("kpp is not null");
            return (Criteria) this;
        }

        public Criteria andKppEqualTo(String value) {
            addCriterion("kpp =", value, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppNotEqualTo(String value) {
            addCriterion("kpp <>", value, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppGreaterThan(String value) {
            addCriterion("kpp >", value, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppGreaterThanOrEqualTo(String value) {
            addCriterion("kpp >=", value, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppLessThan(String value) {
            addCriterion("kpp <", value, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppLessThanOrEqualTo(String value) {
            addCriterion("kpp <=", value, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppLike(String value) {
            addCriterion("kpp like", value, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppNotLike(String value) {
            addCriterion("kpp not like", value, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppIn(List<String> values) {
            addCriterion("kpp in", values, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppNotIn(List<String> values) {
            addCriterion("kpp not in", values, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppBetween(String value1, String value2) {
            addCriterion("kpp between", value1, value2, "kpp");
            return (Criteria) this;
        }

        public Criteria andKppNotBetween(String value1, String value2) {
            addCriterion("kpp not between", value1, value2, "kpp");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andBikIsNull() {
            addCriterion("bik is null");
            return (Criteria) this;
        }

        public Criteria andBikIsNotNull() {
            addCriterion("bik is not null");
            return (Criteria) this;
        }

        public Criteria andBikEqualTo(String value) {
            addCriterion("bik =", value, "bik");
            return (Criteria) this;
        }

        public Criteria andBikNotEqualTo(String value) {
            addCriterion("bik <>", value, "bik");
            return (Criteria) this;
        }

        public Criteria andBikGreaterThan(String value) {
            addCriterion("bik >", value, "bik");
            return (Criteria) this;
        }

        public Criteria andBikGreaterThanOrEqualTo(String value) {
            addCriterion("bik >=", value, "bik");
            return (Criteria) this;
        }

        public Criteria andBikLessThan(String value) {
            addCriterion("bik <", value, "bik");
            return (Criteria) this;
        }

        public Criteria andBikLessThanOrEqualTo(String value) {
            addCriterion("bik <=", value, "bik");
            return (Criteria) this;
        }

        public Criteria andBikLike(String value) {
            addCriterion("bik like", value, "bik");
            return (Criteria) this;
        }

        public Criteria andBikNotLike(String value) {
            addCriterion("bik not like", value, "bik");
            return (Criteria) this;
        }

        public Criteria andBikIn(List<String> values) {
            addCriterion("bik in", values, "bik");
            return (Criteria) this;
        }

        public Criteria andBikNotIn(List<String> values) {
            addCriterion("bik not in", values, "bik");
            return (Criteria) this;
        }

        public Criteria andBikBetween(String value1, String value2) {
            addCriterion("bik between", value1, value2, "bik");
            return (Criteria) this;
        }

        public Criteria andBikNotBetween(String value1, String value2) {
            addCriterion("bik not between", value1, value2, "bik");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNull() {
            addCriterion("bank_account is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNotNull() {
            addCriterion("bank_account is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountEqualTo(String value) {
            addCriterion("bank_account =", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotEqualTo(String value) {
            addCriterion("bank_account <>", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThan(String value) {
            addCriterion("bank_account >", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThanOrEqualTo(String value) {
            addCriterion("bank_account >=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThan(String value) {
            addCriterion("bank_account <", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThanOrEqualTo(String value) {
            addCriterion("bank_account <=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLike(String value) {
            addCriterion("bank_account like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotLike(String value) {
            addCriterion("bank_account not like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountIn(List<String> values) {
            addCriterion("bank_account in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotIn(List<String> values) {
            addCriterion("bank_account not in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountBetween(String value1, String value2) {
            addCriterion("bank_account between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotBetween(String value1, String value2) {
            addCriterion("bank_account not between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountIsNull() {
            addCriterion("cor_account is null");
            return (Criteria) this;
        }

        public Criteria andCorAccountIsNotNull() {
            addCriterion("cor_account is not null");
            return (Criteria) this;
        }

        public Criteria andCorAccountEqualTo(String value) {
            addCriterion("cor_account =", value, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountNotEqualTo(String value) {
            addCriterion("cor_account <>", value, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountGreaterThan(String value) {
            addCriterion("cor_account >", value, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountGreaterThanOrEqualTo(String value) {
            addCriterion("cor_account >=", value, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountLessThan(String value) {
            addCriterion("cor_account <", value, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountLessThanOrEqualTo(String value) {
            addCriterion("cor_account <=", value, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountLike(String value) {
            addCriterion("cor_account like", value, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountNotLike(String value) {
            addCriterion("cor_account not like", value, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountIn(List<String> values) {
            addCriterion("cor_account in", values, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountNotIn(List<String> values) {
            addCriterion("cor_account not in", values, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountBetween(String value1, String value2) {
            addCriterion("cor_account between", value1, value2, "corAccount");
            return (Criteria) this;
        }

        public Criteria andCorAccountNotBetween(String value1, String value2) {
            addCriterion("cor_account not between", value1, value2, "corAccount");
            return (Criteria) this;
        }

        public Criteria andBankIsNull() {
            addCriterion("bank is null");
            return (Criteria) this;
        }

        public Criteria andBankIsNotNull() {
            addCriterion("bank is not null");
            return (Criteria) this;
        }

        public Criteria andBankEqualTo(String value) {
            addCriterion("bank =", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotEqualTo(String value) {
            addCriterion("bank <>", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankGreaterThan(String value) {
            addCriterion("bank >", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankGreaterThanOrEqualTo(String value) {
            addCriterion("bank >=", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLessThan(String value) {
            addCriterion("bank <", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLessThanOrEqualTo(String value) {
            addCriterion("bank <=", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLike(String value) {
            addCriterion("bank like", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotLike(String value) {
            addCriterion("bank not like", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankIn(List<String> values) {
            addCriterion("bank in", values, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotIn(List<String> values) {
            addCriterion("bank not in", values, "bank");
            return (Criteria) this;
        }

        public Criteria andBankBetween(String value1, String value2) {
            addCriterion("bank between", value1, value2, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotBetween(String value1, String value2) {
            addCriterion("bank not between", value1, value2, "bank");
            return (Criteria) this;
        }

        public Criteria andConsigneeIsNull() {
            addCriterion("consignee is null");
            return (Criteria) this;
        }

        public Criteria andConsigneeIsNotNull() {
            addCriterion("consignee is not null");
            return (Criteria) this;
        }

        public Criteria andConsigneeEqualTo(String value) {
            addCriterion("consignee =", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeNotEqualTo(String value) {
            addCriterion("consignee <>", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeGreaterThan(String value) {
            addCriterion("consignee >", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeGreaterThanOrEqualTo(String value) {
            addCriterion("consignee >=", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeLessThan(String value) {
            addCriterion("consignee <", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeLessThanOrEqualTo(String value) {
            addCriterion("consignee <=", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeLike(String value) {
            addCriterion("consignee like", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeNotLike(String value) {
            addCriterion("consignee not like", value, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeIn(List<String> values) {
            addCriterion("consignee in", values, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeNotIn(List<String> values) {
            addCriterion("consignee not in", values, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeBetween(String value1, String value2) {
            addCriterion("consignee between", value1, value2, "consignee");
            return (Criteria) this;
        }

        public Criteria andConsigneeNotBetween(String value1, String value2) {
            addCriterion("consignee not between", value1, value2, "consignee");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andWebSiteIsNull() {
            addCriterion("web_site is null");
            return (Criteria) this;
        }

        public Criteria andWebSiteIsNotNull() {
            addCriterion("web_site is not null");
            return (Criteria) this;
        }

        public Criteria andWebSiteEqualTo(String value) {
            addCriterion("web_site =", value, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteNotEqualTo(String value) {
            addCriterion("web_site <>", value, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteGreaterThan(String value) {
            addCriterion("web_site >", value, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteGreaterThanOrEqualTo(String value) {
            addCriterion("web_site >=", value, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteLessThan(String value) {
            addCriterion("web_site <", value, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteLessThanOrEqualTo(String value) {
            addCriterion("web_site <=", value, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteLike(String value) {
            addCriterion("web_site like", value, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteNotLike(String value) {
            addCriterion("web_site not like", value, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteIn(List<String> values) {
            addCriterion("web_site in", values, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteNotIn(List<String> values) {
            addCriterion("web_site not in", values, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteBetween(String value1, String value2) {
            addCriterion("web_site between", value1, value2, "webSite");
            return (Criteria) this;
        }

        public Criteria andWebSiteNotBetween(String value1, String value2) {
            addCriterion("web_site not between", value1, value2, "webSite");
            return (Criteria) this;
        }

        public Criteria andOgrnIsNull() {
            addCriterion("ogrn is null");
            return (Criteria) this;
        }

        public Criteria andOgrnIsNotNull() {
            addCriterion("ogrn is not null");
            return (Criteria) this;
        }

        public Criteria andOgrnEqualTo(String value) {
            addCriterion("ogrn =", value, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnNotEqualTo(String value) {
            addCriterion("ogrn <>", value, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnGreaterThan(String value) {
            addCriterion("ogrn >", value, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnGreaterThanOrEqualTo(String value) {
            addCriterion("ogrn >=", value, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnLessThan(String value) {
            addCriterion("ogrn <", value, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnLessThanOrEqualTo(String value) {
            addCriterion("ogrn <=", value, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnLike(String value) {
            addCriterion("ogrn like", value, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnNotLike(String value) {
            addCriterion("ogrn not like", value, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnIn(List<String> values) {
            addCriterion("ogrn in", values, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnNotIn(List<String> values) {
            addCriterion("ogrn not in", values, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnBetween(String value1, String value2) {
            addCriterion("ogrn between", value1, value2, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOgrnNotBetween(String value1, String value2) {
            addCriterion("ogrn not between", value1, value2, "ogrn");
            return (Criteria) this;
        }

        public Criteria andOkpoIsNull() {
            addCriterion("okpo is null");
            return (Criteria) this;
        }

        public Criteria andOkpoIsNotNull() {
            addCriterion("okpo is not null");
            return (Criteria) this;
        }

        public Criteria andOkpoEqualTo(String value) {
            addCriterion("okpo =", value, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoNotEqualTo(String value) {
            addCriterion("okpo <>", value, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoGreaterThan(String value) {
            addCriterion("okpo >", value, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoGreaterThanOrEqualTo(String value) {
            addCriterion("okpo >=", value, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoLessThan(String value) {
            addCriterion("okpo <", value, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoLessThanOrEqualTo(String value) {
            addCriterion("okpo <=", value, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoLike(String value) {
            addCriterion("okpo like", value, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoNotLike(String value) {
            addCriterion("okpo not like", value, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoIn(List<String> values) {
            addCriterion("okpo in", values, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoNotIn(List<String> values) {
            addCriterion("okpo not in", values, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoBetween(String value1, String value2) {
            addCriterion("okpo between", value1, value2, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkpoNotBetween(String value1, String value2) {
            addCriterion("okpo not between", value1, value2, "okpo");
            return (Criteria) this;
        }

        public Criteria andOkdvIsNull() {
            addCriterion("okdv is null");
            return (Criteria) this;
        }

        public Criteria andOkdvIsNotNull() {
            addCriterion("okdv is not null");
            return (Criteria) this;
        }

        public Criteria andOkdvEqualTo(String value) {
            addCriterion("okdv =", value, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvNotEqualTo(String value) {
            addCriterion("okdv <>", value, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvGreaterThan(String value) {
            addCriterion("okdv >", value, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvGreaterThanOrEqualTo(String value) {
            addCriterion("okdv >=", value, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvLessThan(String value) {
            addCriterion("okdv <", value, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvLessThanOrEqualTo(String value) {
            addCriterion("okdv <=", value, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvLike(String value) {
            addCriterion("okdv like", value, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvNotLike(String value) {
            addCriterion("okdv not like", value, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvIn(List<String> values) {
            addCriterion("okdv in", values, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvNotIn(List<String> values) {
            addCriterion("okdv not in", values, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvBetween(String value1, String value2) {
            addCriterion("okdv between", value1, value2, "okdv");
            return (Criteria) this;
        }

        public Criteria andOkdvNotBetween(String value1, String value2) {
            addCriterion("okdv not between", value1, value2, "okdv");
            return (Criteria) this;
        }

        public Criteria andIpIdIsNull() {
            addCriterion("ip_id is null");
            return (Criteria) this;
        }

        public Criteria andIpIdIsNotNull() {
            addCriterion("ip_id is not null");
            return (Criteria) this;
        }

        public Criteria andIpIdEqualTo(Integer value) {
            addCriterion("ip_id =", value, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdNotEqualTo(Integer value) {
            addCriterion("ip_id <>", value, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdGreaterThan(Integer value) {
            addCriterion("ip_id >", value, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ip_id >=", value, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdLessThan(Integer value) {
            addCriterion("ip_id <", value, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdLessThanOrEqualTo(Integer value) {
            addCriterion("ip_id <=", value, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdIn(List<Integer> values) {
            addCriterion("ip_id in", values, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdNotIn(List<Integer> values) {
            addCriterion("ip_id not in", values, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdBetween(Integer value1, Integer value2) {
            addCriterion("ip_id between", value1, value2, "ipId");
            return (Criteria) this;
        }

        public Criteria andIpIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ip_id not between", value1, value2, "ipId");
            return (Criteria) this;
        }

        public Criteria andSvSeriesIsNull() {
            addCriterion("sv_series is null");
            return (Criteria) this;
        }

        public Criteria andSvSeriesIsNotNull() {
            addCriterion("sv_series is not null");
            return (Criteria) this;
        }

        public Criteria andSvSeriesEqualTo(String value) {
            addCriterion("sv_series =", value, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesNotEqualTo(String value) {
            addCriterion("sv_series <>", value, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesGreaterThan(String value) {
            addCriterion("sv_series >", value, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesGreaterThanOrEqualTo(String value) {
            addCriterion("sv_series >=", value, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesLessThan(String value) {
            addCriterion("sv_series <", value, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesLessThanOrEqualTo(String value) {
            addCriterion("sv_series <=", value, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesLike(String value) {
            addCriterion("sv_series like", value, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesNotLike(String value) {
            addCriterion("sv_series not like", value, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesIn(List<String> values) {
            addCriterion("sv_series in", values, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesNotIn(List<String> values) {
            addCriterion("sv_series not in", values, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesBetween(String value1, String value2) {
            addCriterion("sv_series between", value1, value2, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvSeriesNotBetween(String value1, String value2) {
            addCriterion("sv_series not between", value1, value2, "svSeries");
            return (Criteria) this;
        }

        public Criteria andSvNumberIsNull() {
            addCriterion("sv_number is null");
            return (Criteria) this;
        }

        public Criteria andSvNumberIsNotNull() {
            addCriterion("sv_number is not null");
            return (Criteria) this;
        }

        public Criteria andSvNumberEqualTo(String value) {
            addCriterion("sv_number =", value, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberNotEqualTo(String value) {
            addCriterion("sv_number <>", value, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberGreaterThan(String value) {
            addCriterion("sv_number >", value, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberGreaterThanOrEqualTo(String value) {
            addCriterion("sv_number >=", value, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberLessThan(String value) {
            addCriterion("sv_number <", value, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberLessThanOrEqualTo(String value) {
            addCriterion("sv_number <=", value, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberLike(String value) {
            addCriterion("sv_number like", value, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberNotLike(String value) {
            addCriterion("sv_number not like", value, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberIn(List<String> values) {
            addCriterion("sv_number in", values, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberNotIn(List<String> values) {
            addCriterion("sv_number not in", values, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberBetween(String value1, String value2) {
            addCriterion("sv_number between", value1, value2, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvNumberNotBetween(String value1, String value2) {
            addCriterion("sv_number not between", value1, value2, "svNumber");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByIsNull() {
            addCriterion("sv_issued_by is null");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByIsNotNull() {
            addCriterion("sv_issued_by is not null");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByEqualTo(String value) {
            addCriterion("sv_issued_by =", value, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByNotEqualTo(String value) {
            addCriterion("sv_issued_by <>", value, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByGreaterThan(String value) {
            addCriterion("sv_issued_by >", value, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByGreaterThanOrEqualTo(String value) {
            addCriterion("sv_issued_by >=", value, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByLessThan(String value) {
            addCriterion("sv_issued_by <", value, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByLessThanOrEqualTo(String value) {
            addCriterion("sv_issued_by <=", value, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByLike(String value) {
            addCriterion("sv_issued_by like", value, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByNotLike(String value) {
            addCriterion("sv_issued_by not like", value, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByIn(List<String> values) {
            addCriterion("sv_issued_by in", values, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByNotIn(List<String> values) {
            addCriterion("sv_issued_by not in", values, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByBetween(String value1, String value2) {
            addCriterion("sv_issued_by between", value1, value2, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvIssuedByNotBetween(String value1, String value2) {
            addCriterion("sv_issued_by not between", value1, value2, "svIssuedBy");
            return (Criteria) this;
        }

        public Criteria andSvDateIsNull() {
            addCriterion("sv_date is null");
            return (Criteria) this;
        }

        public Criteria andSvDateIsNotNull() {
            addCriterion("sv_date is not null");
            return (Criteria) this;
        }

        public Criteria andSvDateEqualTo(Date value) {
            addCriterionForJDBCDate("sv_date =", value, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("sv_date <>", value, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateGreaterThan(Date value) {
            addCriterionForJDBCDate("sv_date >", value, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("sv_date >=", value, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateLessThan(Date value) {
            addCriterionForJDBCDate("sv_date <", value, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("sv_date <=", value, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateIn(List<Date> values) {
            addCriterionForJDBCDate("sv_date in", values, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("sv_date not in", values, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("sv_date between", value1, value2, "svDate");
            return (Criteria) this;
        }

        public Criteria andSvDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("sv_date not between", value1, value2, "svDate");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesIsNull() {
            addCriterion("pasp_series is null");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesIsNotNull() {
            addCriterion("pasp_series is not null");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesEqualTo(String value) {
            addCriterion("pasp_series =", value, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesNotEqualTo(String value) {
            addCriterion("pasp_series <>", value, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesGreaterThan(String value) {
            addCriterion("pasp_series >", value, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesGreaterThanOrEqualTo(String value) {
            addCriterion("pasp_series >=", value, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesLessThan(String value) {
            addCriterion("pasp_series <", value, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesLessThanOrEqualTo(String value) {
            addCriterion("pasp_series <=", value, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesLike(String value) {
            addCriterion("pasp_series like", value, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesNotLike(String value) {
            addCriterion("pasp_series not like", value, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesIn(List<String> values) {
            addCriterion("pasp_series in", values, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesNotIn(List<String> values) {
            addCriterion("pasp_series not in", values, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesBetween(String value1, String value2) {
            addCriterion("pasp_series between", value1, value2, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspSeriesNotBetween(String value1, String value2) {
            addCriterion("pasp_series not between", value1, value2, "paspSeries");
            return (Criteria) this;
        }

        public Criteria andPaspNumberIsNull() {
            addCriterion("pasp_number is null");
            return (Criteria) this;
        }

        public Criteria andPaspNumberIsNotNull() {
            addCriterion("pasp_number is not null");
            return (Criteria) this;
        }

        public Criteria andPaspNumberEqualTo(String value) {
            addCriterion("pasp_number =", value, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberNotEqualTo(String value) {
            addCriterion("pasp_number <>", value, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberGreaterThan(String value) {
            addCriterion("pasp_number >", value, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberGreaterThanOrEqualTo(String value) {
            addCriterion("pasp_number >=", value, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberLessThan(String value) {
            addCriterion("pasp_number <", value, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberLessThanOrEqualTo(String value) {
            addCriterion("pasp_number <=", value, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberLike(String value) {
            addCriterion("pasp_number like", value, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberNotLike(String value) {
            addCriterion("pasp_number not like", value, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberIn(List<String> values) {
            addCriterion("pasp_number in", values, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberNotIn(List<String> values) {
            addCriterion("pasp_number not in", values, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberBetween(String value1, String value2) {
            addCriterion("pasp_number between", value1, value2, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspNumberNotBetween(String value1, String value2) {
            addCriterion("pasp_number not between", value1, value2, "paspNumber");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByIsNull() {
            addCriterion("pasp_issued_by is null");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByIsNotNull() {
            addCriterion("pasp_issued_by is not null");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByEqualTo(String value) {
            addCriterion("pasp_issued_by =", value, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByNotEqualTo(String value) {
            addCriterion("pasp_issued_by <>", value, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByGreaterThan(String value) {
            addCriterion("pasp_issued_by >", value, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByGreaterThanOrEqualTo(String value) {
            addCriterion("pasp_issued_by >=", value, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByLessThan(String value) {
            addCriterion("pasp_issued_by <", value, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByLessThanOrEqualTo(String value) {
            addCriterion("pasp_issued_by <=", value, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByLike(String value) {
            addCriterion("pasp_issued_by like", value, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByNotLike(String value) {
            addCriterion("pasp_issued_by not like", value, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByIn(List<String> values) {
            addCriterion("pasp_issued_by in", values, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByNotIn(List<String> values) {
            addCriterion("pasp_issued_by not in", values, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByBetween(String value1, String value2) {
            addCriterion("pasp_issued_by between", value1, value2, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspIssuedByNotBetween(String value1, String value2) {
            addCriterion("pasp_issued_by not between", value1, value2, "paspIssuedBy");
            return (Criteria) this;
        }

        public Criteria andPaspDateIsNull() {
            addCriterion("pasp_date is null");
            return (Criteria) this;
        }

        public Criteria andPaspDateIsNotNull() {
            addCriterion("pasp_date is not null");
            return (Criteria) this;
        }

        public Criteria andPaspDateEqualTo(Date value) {
            addCriterionForJDBCDate("pasp_date =", value, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("pasp_date <>", value, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateGreaterThan(Date value) {
            addCriterionForJDBCDate("pasp_date >", value, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("pasp_date >=", value, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateLessThan(Date value) {
            addCriterionForJDBCDate("pasp_date <", value, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("pasp_date <=", value, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateIn(List<Date> values) {
            addCriterionForJDBCDate("pasp_date in", values, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("pasp_date not in", values, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("pasp_date between", value1, value2, "paspDate");
            return (Criteria) this;
        }

        public Criteria andPaspDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("pasp_date not between", value1, value2, "paspDate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}